insert overwrite table jms_dwm.dwm_network_target_detail_dt PARTITION (dt)
select
      target_name          --'指标名称'
     ,target_code          --'指标code'
     ,target_table         --'指标所在表'
     ,target_column        --'指标所用字段'
     ,target_user          --'指标维护人'
     ,target_refresh_cycle --'指标回刷周期'
     ,target_time          --'指标时间属性，例：揽收，签收'
     ,update_time          --'维护时间（更新时间）'
     ,network_name         --'网点'
     ,network_code         --'网点code'
     ,target_value         --'指标值'
     ,remark               --'备注'
     ,dt
from jms_dwm.dwm_network_target_detail_mid_dt where dt>=date_sub('{{ execution_date | cst_ds }}',90) and dt<date_add('{{ execution_date | cst_ds }}',1)
 distribute by dt ;